create database MusicOnline
use MusicOnline

create table Category
(
	id varchar(10) primary key,
	CatName nvarchar(50),
	favorite int 	
)

create proc [dbo].[MusicOnline_GetAll]
as
select * from Category

Execute MusicOnline_GetAll

create proc [dbo].[MusicOnline_InsertCate]
@id varchar(10),
@CatName nvarchar(50),
@favorite int
as
insert into Category values (@id,@CatName,@favorite)

Execute MusicOnline_InsertCate '001',N'Nhạc Việt','9'
Execute MusicOnline_InsertCate '002',N'Nhạc Anh','10'
Execute MusicOnline_InsertCate '003',N'Nhạc Trung Quốc','1'
Execute MusicOnline_InsertCate '004',N'Nhạc không lời','9'	